package com.opo5.logisticsmanagement.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.opo5.logisticsmanagement.Vo.NewVo;
import com.opo5.logisticsmanagement.Vo.SpareVo;
import com.opo5.logisticsmanagement.domain.New;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface NewDao extends BaseMapper<New> {
    @Select("SELECT s.materialdescribe,s.innum,s.outnum,d.date,s.projectname\n" +
            "FROM tbs_new s\n" +
            "JOIN tbs_wu_spare w\n" +
            "ON s.id=w.id\n" +
            "JOIN tbs_date d\n" +
            "ON d.id=w.id")
    Page<NewVo> newpro(Page<NewVo> iPage);
}
